#ifndef _SQLITEDATAPROVIDER_H
#define _SQLITEDATAPROVIDER_H

#define SQLFILE "./tables.sql"
#define MAXROWS 128

#include "sqlite3.h"
#include "common.h"
#include "string.h"
#include "util.h"

int insertmp3Info(sqlite3 **ppDb, id3filedata *mp3data,int isUpdate = 0);
int initDatabase(char *filename,sqlite3 **ppDb);
int deInit(sqlite3 *db);
int sqliteExecute(sqlite3 *db,const  char *query, int (*callback1)(void*,int,char**,char**),void * arg);
int getData(sqlite3 **db,char *query, arraycontainer *results);
int insertjpgInfo(sqlite3 **ppDb, exiffiledata *exifdata,int isUpdate = 0);
int getData(sqlite3 **ppDb,char *query,arraycontainer *results);
int insertFileInfo(sqlite3 **db,struct stat *stbuf,char *filePath,int isUpdate = 0);
int insertCustomInfo(sqlite3 **ppDb,keyvaluecontainer *container,char *filepath,int isUpdate = 0);

#endif
